﻿<%@ Page Language="C#" MasterPageFile="~/WebSite/teacher.master" AutoEventWireup="true" CodeFile="t_data_contrast.aspx.cs" Inherits="WebSite_t_data_contrast" Title="数据对比" %>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder2" runat="server">
    <style type="text/css">
    .AddStyle
    {
    	margin-top:15px;
    	margin-left:240px;
    	width:90px;
    	height:30px;
    	background-color:#669DF0;
    	font-size:16px;
    	font-weight:bold;
    	color:#FFFFFF;
    }
    .TableName
    {
    	margin-left:240px;
    	margin-top:30px;
   	}
 </style>
    <p align="left">
        <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
        选择要对比的对象<br />
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>
<p style="width: 666px">
        省份<asp:DropDownList ID="DropDownList_pro1" runat="server" Height="20px" 
            Width="54px" DataSourceID="SqlDataSource1" DataTextField="Column1" 
            DataValueField="Column1">
        </asp:DropDownList>
        性别<asp:DropDownList ID="DropDownList_sex1" runat="server" Width="54px">
            <asp:ListItem>全部</asp:ListItem>
            <asp:ListItem Value="男">男</asp:ListItem>
            <asp:ListItem Value="女">女</asp:ListItem>
        </asp:DropDownList>
        &nbsp;年份<asp:DropDownList ID="DropDownList_year1" runat="server" Width="54px" 
            Height="20px">
            <asp:ListItem Value="2007">2010</asp:ListItem>
            <asp:ListItem Value="2008">2009</asp:ListItem>
            <asp:ListItem Value="2009">2008</asp:ListItem>
            <asp:ListItem Value="2010">2007</asp:ListItem>
        </asp:DropDownList>
        年级<asp:DropDownList ID="DropDownList_grade1" runat="server" 
            Width="54px">
            <asp:ListItem>全部</asp:ListItem>
            <asp:ListItem Value="2006">2006</asp:ListItem>
            <asp:ListItem Value="2007">2007</asp:ListItem>
            <asp:ListItem Value="2008">2008</asp:ListItem>
            <asp:ListItem Value="2009">2009</asp:ListItem>
        </asp:DropDownList>
        专业<asp:DropDownList ID="DropDownList_major1" runat="server" Width="54px" 
            DataSourceID="XmlDataSource1" DataTextField="College" DataValueField="College" 
            Height="20px">
        </asp:DropDownList>
        项目<asp:DropDownList ID="DropDownList_item1" runat="server" Width="54px">
            <asp:ListItem>全部</asp:ListItem>
            <asp:ListItem>肺活量</asp:ListItem>
            <asp:ListItem>身高体重指数</asp:ListItem>
            <asp:ListItem>台阶试验</asp:ListItem>
            <asp:ListItem>握力</asp:ListItem>
            <asp:ListItem>仰卧起坐</asp:ListItem>
            <asp:ListItem>坐位体前屈</asp:ListItem>
            <asp:ListItem>跳绳</asp:ListItem>
            <asp:ListItem>立定跳远</asp:ListItem>
        </asp:DropDownList>
        民族<asp:DropDownList ID="DropDownList_national1" runat="server" Width="54px" 
            DataSourceID="SqlDataSource2" DataTextField="Nationality" 
            DataValueField="Nationality">
        </asp:DropDownList>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:CSHDBConnectionString %>" 
            SelectCommand="SELECT LTRIM(RTRIM(Nationality))  AS Nationality FROM NationalityTable">
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
            ConnectionString="<%$ ConnectionStrings:CSHDBConnectionString %>" 
            
            SelectCommand="SELECT distinct(LTRIM(RTRIM(TestName)))  AS TestName FROM TaskIDTable">
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:CSHDBConnectionString %>" 
            SelectCommand="select ltrim(rtrim(cityname)) from provincetable where cityid=provinceid"></asp:SqlDataSource>
        <asp:XmlDataSource ID="XmlDataSource1" runat="server" 
            DataFile="~/WebSite/CollegeName.xml" TransformFile="~/WebSite/CollegeName.xslt">
        </asp:XmlDataSource>
                            </p>
<p style="height: 73px; width: 655px">
        <br />
        省份<asp:DropDownList ID="DropDownList_pro2" runat="server" Width="54px" 
            DataSourceID="SqlDataSource1" DataTextField="Column1" DataValueField="Column1">
        </asp:DropDownList>
        性别<asp:DropDownList ID="DropDownList_sex2" runat="server" Width="54px">
            <asp:ListItem>全部</asp:ListItem>
            <asp:ListItem Value="男">男</asp:ListItem>
            <asp:ListItem Value="女">女</asp:ListItem>
        </asp:DropDownList>
        &nbsp;年份<asp:DropDownList ID="DropDownList_year2" runat="server" Width="54px">
            <asp:ListItem Value="2010">2010</asp:ListItem>
            <asp:ListItem Value="2009">2009</asp:ListItem>
            <asp:ListItem Value="2008">2008</asp:ListItem>
            <asp:ListItem Value="2007">2007</asp:ListItem>
        </asp:DropDownList>
        年级<asp:DropDownList ID="DropDownList_grade2" runat="server" Width="54px">
            <asp:ListItem>全部</asp:ListItem>
            <asp:ListItem>2006</asp:ListItem>
            <asp:ListItem>2007</asp:ListItem>
            <asp:ListItem>2008</asp:ListItem>
            <asp:ListItem>2009</asp:ListItem>
        </asp:DropDownList>
        &nbsp;专业<asp:DropDownList ID="DropDownList_major2" runat="server" 
            DataSourceID="XmlDataSource1" DataTextField="College" DataValueField="College" 
            Width="54px">
        </asp:DropDownList>
        项目<asp:DropDownList ID="DropDownList_item2" runat="server" Width="54px">
            <asp:ListItem>全部</asp:ListItem>
            <asp:ListItem>肺活量</asp:ListItem>
            <asp:ListItem>身高体重指数</asp:ListItem>
            <asp:ListItem>台阶试验</asp:ListItem>
            <asp:ListItem>握力</asp:ListItem>
            <asp:ListItem>仰卧起坐</asp:ListItem>
            <asp:ListItem>坐位体前屈</asp:ListItem>
        </asp:DropDownList>
        民族<asp:DropDownList ID="DropDownList_national2" runat="server" Width="54px" 
            DataSourceID="SqlDataSource2" DataTextField="Nationality" 
            DataValueField="Nationality">
        </asp:DropDownList>
        <br />
        <br />
        <asp:Button ID="Button1" runat="server" Text="开始对比" onclick="Button1_Click" CssClass="AddStyle" />
    </p>
    <br/>
    <br/>
    <asp:CHART id="Chart1" runat="server" Palette="Pastel" BackColor="192, 192, 255" 
                ImageType="Png" ImageLocation="~/TempImages/ChartPic_#SEQ(300,3)" Width="635px" 
                Height="370px" BorderDashStyle="Solid" BackGradientStyle="TopBottom" 
                BorderWidth="2" BorderColor="26, 59, 105" 
                BackImageTransparentColor="White" BackSecondaryColor="255, 255, 192">
							<titles>
								<asp:Title ShadowColor="32, 0, 0, 0" Font="宋体, 14.25pt, style=Bold" 
                                    ShadowOffset="3" Text="对比运算结果" ForeColor="26, 59, 105"></asp:Title>
							</titles>
							<legends>
								<asp:Legend Enabled="False" IsTextAutoFit="true" Name="Default" BackColor="Transparent" Font="宋体, 13px, style=Bold"></asp:Legend>
							</legends>
							<borderskin SkinStyle="Emboss"></borderskin>
							<series>
							</series>
							<chartareas>
								<asp:ChartArea Name="ChartArea1" BorderColor="64, 64, 64, 64" BackSecondaryColor="Transparent" BackColor="0,0,0,0" ShadowColor="Transparent" BackGradientStyle="TopBottom">
									<area3dstyle Rotation="10" Perspective="10" Enable3D="True" Inclination="15" IsRightAngleAxes="False" WallWidth="0" IsClustered="False" />
									<axisy LineColor="64, 64, 64, 64">
										<LabelStyle Font="Trebuchet MS, 8.25pt, style=Bold" />
										<MajorGrid LineColor="64, 64, 64, 64" />
									</axisy>
									<axisx LineColor="64, 64, 64, 64">
										<LabelStyle Font="Trebuchet MS, 8.25pt, style=Bold" />
										<MajorGrid LineColor="64, 64, 64, 64" />
									</axisx>
								</asp:ChartArea>
							</chartareas>
						</asp:CHART>
</asp:Content>
